<?xml version="1.0"?>
<Map>
  <DbToCS>
    <DbToCS key="nchar" value="string" />
    <DbToCS key="date" value="DateTime" />
    <DbToCS key="uniqueide" value="Guid" />
    <DbToCS key="numeric" value="decimal" />
    <DbToCS key="varchar" value="string" />
    <DbToCS key="nvarchar" value="string" />
    <DbToCS key="integer" value="int" />
    <DbToCS key="datetime" value="DateTime" />
    <DbToCS key="long raw" value="byte[]" />
    <DbToCS key="uniqueidentifier" value="Guid" />
    <DbToCS key="raw" value="byte[]" />
    <DbToCS key="smalldatetime" value="DateTime" />
    <DbToCS key="string" value="string" />
    <DbToCS key="money" value="decimal" />
    <DbToCS key="real" value="decimal" />
    <DbToCS key="blob" value="byte[]" />
    <DbToCS key="timestamp" value="DateTime" />
    <DbToCS key="bit" value="bool" />
    <DbToCS key="smallint" value="int" />
    <DbToCS key="tinyint" value="int" />
    <DbToCS key="ntext" value="string" />
    <DbToCS key="single" value="Single" />
    <DbToCS key="smallmoney" value="decimal" />
    <DbToCS key="int" value="int" />
    <DbToCS key="decimal" value="decimal" />
    <DbToCS key="bfile" value="byte[]" />
    <DbToCS key="float" value="decimal" />
    <DbToCS key="text" value="string" />
    <DbToCS key="binary" value="byte[]" />
    <DbToCS key="char" value="string" />
    <DbToCS key="number" value="decimal" />
    <DbToCS key="image" value="byte[]" />
    <DbToCS key="varchar2" value="string" />
    <DbToCS key="nvarchar2" value="string" />
    <DbToCS key="time" value="DateTime" />
    <DbToCS key="varbinary" value="byte[]" />
    <DbToCS key="boolean" value="bool" />
    <DbToCS key="bigint" value="long" />
    <DbToCS key="long" value="byte[]" />
    <DbToCS key="longtext" value="string" />
    <DbToCS key="sysname" value="string" />
  </DbToCS>
  <SQLDbType>

    <SQLDbType key="BigInt" value="Int64" />
    <SQLDbType key="Binary" value="byte" />
    <SQLDbType key="Bit" value="bool" />
    <SQLDbType key="Char" value="char" />
    <SQLDbType key="DateTime" value="DateTime" />
    <SQLDbType key="Decimal" value="decimal" />
    <SQLDbType key="Float" value="float" />
    <SQLDbType key="Image" value="byte[]" />
    <SQLDbType key="Int" value="int" />
    <SQLDbType key="Money" value="decimal" />
    <SQLDbType key="Nchar" value="string" />
    <SQLDbType key="Ntext" value="string" />
    <SQLDbType key="NVarChar" value="string" />
    <SQLDbType key="Real" value="double" />
    <SQLDbType key="UniqueIdentifier" value="Int64" />
    <SQLDbType key="SmallDateTime" value="DateTime" />
    <SQLDbType key="SmallInt" value="Int16" />
    <SQLDbType key="SmallMoney" value="decimal" />
    <SQLDbType key="Text" value="string" />
    <SQLDbType key="Timestamp" value="DateTime" />
    <SQLDbType key="TinyInt" value="byte" />
    <SQLDbType key="VarBinary" value="byte[]" />
    <SQLDbType key="VarChar" value="string" />
    <SQLDbType key="Variant" value="object" />
    <SQLDbType key="Xml" value="object" />
    <SQLDbType key="Udt" value="object" />
    <SQLDbType key="Structured" value="object" />
    <SQLDbType key="Date" value="DateTime" />
    <SQLDbType key="Time" value="DateTime" />
    <SQLDbType key="DateTime2" value="DateTime" />
    <SQLDbType key="DateTimeOffset" value="TimeSpan" />

    
  </SQLDbType>
  <OraDbType>
    <OraDbType key="blob" value="Blob" />
    <OraDbType key="nvarchar2" value="NVarChar" />
    <OraDbType key="int" value="Number" />
    <OraDbType key="varchar2" value="VarChar" />
    <OraDbType key="long raw" value="LongRaw" />
    <OraDbType key="date" value="DateTime" />
    <OraDbType key="long" value="LongVarChar" />
    <OraDbType key="raw" value="Raw" />
    <OraDbType key="nchar" value="NChar" />
    <OraDbType key="bfile" value="BFile" />
    <OraDbType key="number" value="Number" />
    <OraDbType key="nclob" value="NClob" />
    <OraDbType key="clob" value="Clob" />
    <OraDbType key="bit" value="Clob" />
    <OraDbType key="char" value="Char" />
    <OraDbType key="string" value="VarChar" />
  </OraDbType>
  <MySQLDbType>
    <MySQLDbType key="Decimal" value="decimal" />
    <MySQLDbType key="Byte" value="byte" />
    <MySQLDbType key="Int16" value="int16" />
    <MySQLDbType key="Int32" value="int" />
    <MySQLDbType key="Float" value="decimal" />
    <MySQLDbType key="Double" value="double" />
    <MySQLDbType key="Timestamp" value="DateTime" />
    <MySQLDbType key="Int64" value="int64" />
    <MySQLDbType key="Int24" value="int32" />
    <MySQLDbType key="Date" value="DateTime" />
    <MySQLDbType key="Time" value="DateTime" />
    <MySQLDbType key="DateTime" value="DateTime" />
    <MySQLDbType key="Year" value="int" />
    <MySQLDbType key="Newdate" value="string" />
    <MySQLDbType key="VarString" value="string" />
    <MySQLDbType key="Bit" value="bool" />
    <MySQLDbType key="NewDecimal" value="dDecimal" />
    <MySQLDbType key="Enum" value="int" />
    <MySQLDbType key="Set" value="byte[]" />
    <MySQLDbType key="TinyBlob" value="byte[]" />
    <MySQLDbType key="MediumBlob" value="byte[]" />
    <MySQLDbType key="LongBlob" value="byte[]" />
    <MySQLDbType key="Blob" value="byte[]" />
    <MySQLDbType key="VarChar" value="string" />
    <MySQLDbType key="String" value="string" />
    <MySQLDbType key="Geometry" value="byte[]" />
    <MySQLDbType key="UByte" value="byte" />
    <MySQLDbType key="UInt16" value="uInt16" />
    <MySQLDbType key="UInt32" value="uInt32" />
    <MySQLDbType key="UInt64" value="uInt64" />
    <MySQLDbType key="UInt24" value="uInt32" />
    <MySQLDbType key="Binary" value="byte" />
    <MySQLDbType key="VarBinary" value="byte[]" />
    <MySQLDbType key="TinyText" value="string" />
    <MySQLDbType key="MediumText" value="string" />
    <MySQLDbType key="LongText" value="string" />
    <MySQLDbType key="Text" value="string" />
    <MySQLDbType key="Guid" value="string" />
    <MySQLDbType key="Int" value="int"  DBType="Int32"/>
    <MySQLDbType key="BigInt" value="Int64"  DBType="Int64"/>


  </MySQLDbType>
  <OleDbDbType>
    <OleDbDbType key="decimal" value="Decimal" />
    <OleDbDbType key="smalldatetime" value="Date" />
    <OleDbDbType key="text" value="LongVarChar" />
    <OleDbDbType key="tinyint" value="TinyInt" />
    <OleDbDbType key="bit" value="Boolean" />
    <OleDbDbType key="float" value="Decimal" />
    <OleDbDbType key="bigint" value="BigInt" />
    <OleDbDbType key="single" value="Single" />
    <OleDbDbType key="nvarchar" value="LongVarChar" />
    <OleDbDbType key="ntext" value="LongVarChar" />
    <OleDbDbType key="varchar" value="VarChar" />
    <OleDbDbType key="smallmoney" value="Decimal" />
    <OleDbDbType key="byte" value="Binary" />
    <OleDbDbType key="string" value="VarChar" />
    <OleDbDbType key="datetime" value="Date" />
    <OleDbDbType key="int" value="Integer" />
    <OleDbDbType key="double" value="Double" />
    <OleDbDbType key="bool" value="Boolean" />
    <OleDbDbType key="numeric" value="Decimal" />
    <OleDbDbType key="short" value="SmallInt" />
    <OleDbDbType key="nchar" value="NChar" />
    <OleDbDbType key="money" value="Decimal" />
    <OleDbDbType key="smallint" value="SmallInt" />
    <OleDbDbType key="binary" value="Binary" />
    <OleDbDbType key="char" value="Char" />
  </OleDbDbType>
  <SQLiteType>
    <SQLiteType key="blob" value="Binary" />
    <SQLiteType key="decimal" value="Decimal" />
    <SQLiteType key="boolean" value="Boolean" />
    <SQLiteType key="time" value="Time" />
    <SQLiteType key="float" value="Decimal" />
    <SQLiteType key="nvarchar" value="String" />
    <SQLiteType key="numeric" value="Decimal" />
    <SQLiteType key="varchar" value="String" />
    <SQLiteType key="real" value="Decimal" />
    <SQLiteType key="datetime" value="DateTime" />
    <SQLiteType key="integer" value="Int32" />
    <SQLiteType key="int" value="Int32" />
    <SQLiteType key="byte" value="Byte" />
    <SQLiteType key="text" value="String" />
    <SQLiteType key="money" value="Decimal" />
    <SQLiteType key="varbinary" value="Binary" />
    <SQLiteType key="binary" value="Binary" />
    <SQLiteType key="date" value="Date" />
    <SQLiteType key="double" value="Double" />
  </SQLiteType>
  <AddMark>
    <AddMark key="smalldatetime" value="true" />
    <AddMark key="ntext" value="true" />
    <AddMark key="varchar2" value="true" />
    <AddMark key="clob" value="true" />
    <AddMark key="string" value="true" />
    <AddMark key="nvarchar2" value="true" />
    <AddMark key="char" value="true" />
    <AddMark key="uniqueidentifier" value="true" />
    <AddMark key="datetime" value="true" />
    <AddMark key="text" value="true" />
    <AddMark key="date" value="true" />
    <AddMark key="nvarchar" value="true" />
    <AddMark key="nchar" value="true" />
    <AddMark key="time" value="true" />
    <AddMark key="varchar" value="true" />
  </AddMark>
  <ValueType>
    <ValueType key="decimal" value="true" />
    <ValueType key="Int32" value="true" />
    <ValueType key="DateTime" value="true" />
    <ValueType key="long" value="true" />
    <ValueType key="double" value="true" />
    <ValueType key="Int64" value="true" />
    <ValueType key="int" value="true" />
    <ValueType key="Int16" value="true" />
    <ValueType key="Decimal" value="true" />
    <ValueType key="char" value="true" />
    <ValueType key="bool" value="true" />
  </ValueType>
  <AccessTypeMap>
    <AccessTypeMap key="205" value="image" />
    <AccessTypeMap key="11" value="bit" />
    <AccessTypeMap key="203" value="text" />
    <AccessTypeMap key="135" value="smalldatetime" />
    <AccessTypeMap key="202" value="varchar" />
    <AccessTypeMap key="133" value="datetime" />
    <AccessTypeMap key="200" value="varchar" />
    <AccessTypeMap key="17" value="byte" />
    <AccessTypeMap key="128" value="binary" />
    <AccessTypeMap key="130" value="varchar" />
    <AccessTypeMap key="72" value="uniqueidentifier" />
    <AccessTypeMap key="204" value="binary" />
    <AccessTypeMap key="4" value="single" />
    <AccessTypeMap key="5" value="double" />
    <AccessTypeMap key="6" value="money" />
    <AccessTypeMap key="7" value="datetime" />
    <AccessTypeMap key="2" value="short" />
    <AccessTypeMap key="3" value="int" />
    <AccessTypeMap key="13" value="timestamp" />
    <AccessTypeMap key="129" value="char" />
    <AccessTypeMap key="131" value="float" />
    <AccessTypeMap key="201" value="text" />
  </AccessTypeMap>
  <ParamePrefix>
    <ParamePrefix key="OLEDB" value="@" />
    <ParamePrefix key="MYSQL" value="@" />
    <ParamePrefix key="ORACLE" value=":" />
    <ParamePrefix key="SQLITE" value="@" />
    <ParamePrefix key="SQL2000" value="@" />
    <ParamePrefix key="SQL2008" value="@" />
    <ParamePrefix key="SQL2005" value="@" />
  </ParamePrefix>
</Map>